UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PItuJV8JYuajZqwCEQVqymVjPg0Giv+W0F5dqbNU2S8='
WHERE
key_id = '78aad14a4de3c97afee7fa6b0ac0e565f498a13cdf710c0fa8585f56502488ba'
AND (
token = 'PItuJV8JYuajZqwCEQVqymVjPg0Giv+W0F5dqbNU2S8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)