UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hg7BMWm2iOhkqQtw1WdQrTyCHeyx1pD5glVLW09k7ZY='
WHERE
key_id = 'ee442b96662fd6a760401b71702b4ea67e6e8cacb7efe7f2020165af26eb0ea4'
AND (
token = 'hg7BMWm2iOhkqQtw1WdQrTyCHeyx1pD5glVLW09k7ZY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)