UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TOlE/q8EHUTeNzatJUxvSQHoYAKZll0neq/2VvUlxxk='
WHERE
key_id = '46a1798f6fd23277e96864a0a6f21b122004a8a0c8c55eed8491615a0c2a4ea5'
AND (
token = 'TOlE/q8EHUTeNzatJUxvSQHoYAKZll0neq/2VvUlxxk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)