UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '11JMbCZViJ15ChGABpChVuKjJocxE5JpSQ7Ws92L95k='
WHERE
key_id = 'e7c8a895e9d99c73ce202bf8c6bc25a2ec5ba32cbf56710806d7ecac170ee997'
AND (
token = '11JMbCZViJ15ChGABpChVuKjJocxE5JpSQ7Ws92L95k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)