UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H6cZ4YpBy8Lfjs/Bt7n4vLLI0XM1NGsUBVL3CquKZpI='
WHERE
key_id = 'c1d263d8d4eddac40dad2c57bc37d6a64cee0201f01622f1794bcbec204a9305'
AND (
token = 'H6cZ4YpBy8Lfjs/Bt7n4vLLI0XM1NGsUBVL3CquKZpI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)