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