UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6S634HpnlIJzOeNg3GDaGcMrn+WzrpaLIfEfd8WuDfw='
WHERE
key_id = '0d8d64fe5369e897919cf9e7d09406b26b7bb6116d9bb8fdb3925ebb8e1acaf4'
AND (
token = '6S634HpnlIJzOeNg3GDaGcMrn+WzrpaLIfEfd8WuDfw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)