UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9oHFl4N6ABlq435pmnek5wBOWcjOC9dmIc4HDFMgMvE='
WHERE
key_id = 'a17f07c31767bc0667cbf1a830ff3de498cc491cd4cea92067aaf92a26156927'
AND (
token = '9oHFl4N6ABlq435pmnek5wBOWcjOC9dmIc4HDFMgMvE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)