UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3sZeHOVawWg7tccRADQFUuNQYk8R1VMYMc4MkRMYun4='
WHERE
key_id = '7a7a4fd3754ca02123c80c22b21667d0730991ef7a0869afa898a36ff0c1b074'
AND (
token = '3sZeHOVawWg7tccRADQFUuNQYk8R1VMYMc4MkRMYun4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)