UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zZzwiG4lv8sBwfdFGHPWlVVV1lbwHmzCe56Vmfd+wKg='
WHERE
key_id = '7fdb07b0b60b91b58406fa1e05d0a8a109d60662f8289ce6e6c8a7edc4ac0dab'
AND (
token = 'zZzwiG4lv8sBwfdFGHPWlVVV1lbwHmzCe56Vmfd+wKg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)