UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BWxwlCOygh9wCxgPpjRTicgGnrxtnPUBSN0EHA4p+J8='
WHERE
key_id = '03660eb7af300669a3413c9c9c67b77e517804db5f7a878322f7897cf8521bd9'
AND (
token = 'BWxwlCOygh9wCxgPpjRTicgGnrxtnPUBSN0EHA4p+J8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)