UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Znojx+UWi6CVJ19lWKK0/ScboxKK8LQEzQbgtP5hjxM='
WHERE
key_id = 'b5f923cfd209db58a9e84aabe12e700ce2f3fec5910469430380f8332608b139'
AND (
token = 'Znojx+UWi6CVJ19lWKK0/ScboxKK8LQEzQbgtP5hjxM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)