UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x1gHgXnz6mxPmR+fKZMgeqZjSZic4YcmfYqcFSqaMUY='
WHERE
key_id = 'd1ee4d8dc03576466ccbd42b04491504bf6c95804b37fbc4e033b04f7e7336bb'
AND (
token = 'x1gHgXnz6mxPmR+fKZMgeqZjSZic4YcmfYqcFSqaMUY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)