UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zt5aPO6yJ0oDK9TYlTVLQfe0FEsKwcL1ZyRLf/1WqNY='
WHERE
key_id = '5783f66721c7a5a5b93011b8d5a19f0bff2e6813fff0d1de8e3f77d992fe5cd4'
AND (
token = 'zt5aPO6yJ0oDK9TYlTVLQfe0FEsKwcL1ZyRLf/1WqNY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)