UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yjJicH6yym9Nwbofpcv5k5JqT1FkiaX3mQ7dPgg7mgk='
WHERE
key_id = '54bf6123ddd30f809c81560a6bef5c9e00ce7de6ae5fd536cf50664b0451f82a'
AND (
token = 'yjJicH6yym9Nwbofpcv5k5JqT1FkiaX3mQ7dPgg7mgk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)