UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tYSj7OwqE2efCtF2fdT9gsf479rjFp3ZU4fdabKfjFo='
WHERE
key_id = '3401c82a451a61f17984f8f814246dc017aa838830035a6a98298233e23d9eaf'
AND (
token = 'tYSj7OwqE2efCtF2fdT9gsf479rjFp3ZU4fdabKfjFo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)