UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xtQqbBrfFbL4WQlNuaqD+TO2Ev4OZzzOSkikGx1ulIs='
WHERE
key_id = '47e5e1f1aa26206629ed6d240a89a7d02cb77de0b4fedeb78b7edf2cbac40fa5'
AND (
token = 'xtQqbBrfFbL4WQlNuaqD+TO2Ev4OZzzOSkikGx1ulIs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)