UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7SzavZb00VvwfTGKY9+lgHm2lEwwZssB7Re0IYOk3y0='
WHERE
key_id = 'd80ad3df48d33ad2cdfb084473a22d0c3c7c45a8280d842b88074af1f2ab164d'
AND (
token = '7SzavZb00VvwfTGKY9+lgHm2lEwwZssB7Re0IYOk3y0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)