UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0u+2G35EycabgPj5RHtQnyxQElIlabIH+22CyLJkqws='
WHERE
key_id = 'aff5f4bd0c4526817dc61aafe4dcdb0a0d2df5a2ebacdd43013dcadab02ff34e'
AND (
token = '0u+2G35EycabgPj5RHtQnyxQElIlabIH+22CyLJkqws='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)