UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '172A0HToxT8qGBJEtUBdsy2FF5AZ9LxoPFvEx+/1kIU='
WHERE
key_id = 'b73fae7c84964057f6aa6fa9e25380b98c84020209957425924f354ba837c446'
AND (
token = '172A0HToxT8qGBJEtUBdsy2FF5AZ9LxoPFvEx+/1kIU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)