UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CsdYhTdUuBn95eXYdgNDmxgrIEdks5fEdYZmiRCTvVI='
WHERE
key_id = '412b2197d1a6511e6fd64a9f567e82601b8826569fed38b3369da37c69168f5e'
AND (
token = 'CsdYhTdUuBn95eXYdgNDmxgrIEdks5fEdYZmiRCTvVI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)