UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lJCfOEXdyCIVauhA97j6/XsFr9Ew/9yOunLcx0Fs4EU='
WHERE
key_id = 'bb51c03161b48383693bb9e6e97995a6525c585e8483ead31f15c6ccebd787de'
AND (
token = 'lJCfOEXdyCIVauhA97j6/XsFr9Ew/9yOunLcx0Fs4EU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)