UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GxMS4o3QlCGU1ch75LzEGtGIJEV56sl8lHWnVoniXR8='
WHERE
key_id = '49cf27a4173d7974884bb4a60b5e318c5c5ab420db93421eaafc53943e74c9bd'
AND (
token = 'GxMS4o3QlCGU1ch75LzEGtGIJEV56sl8lHWnVoniXR8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)