UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/hWcT+b6A/yJbsCK6uqXLEdhy8+LeryF3GltSmjW4Ro='
WHERE
key_id = '4a607b5c2a1286b75ec76c85d972745f9d81f45365877a89cc3930ac4abb2db2'
AND (
token = '/hWcT+b6A/yJbsCK6uqXLEdhy8+LeryF3GltSmjW4Ro='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)