UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BU8oTByjL+KoBeCmrER0QJ89pEHkngznGrL4uK3Jfvw='
WHERE
key_id = 'dee50f58c0503df348677681b23203e63a8451adbb4720b011ad7479f5d5ad1b'
AND (
token = 'BU8oTByjL+KoBeCmrER0QJ89pEHkngznGrL4uK3Jfvw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)