UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0QnffOPk7jOUvgbl+MOyI0shptQDRCOzcVJ19H0/dq4='
WHERE
key_id = '4ec19d067766c7bba793bc61998aa55a9dbe4a9e90ee84935ae75f57085850bb'
AND (
token = '0QnffOPk7jOUvgbl+MOyI0shptQDRCOzcVJ19H0/dq4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)