UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UgWDnhBc+j2tU0j6eseFn/mnSMYh5GAZp5EILKPZddE='
WHERE
key_id = '994c9e38815174a800555bbbba5266e716797aeb276b63b1b5186d1949f45f52'
AND (
token = 'UgWDnhBc+j2tU0j6eseFn/mnSMYh5GAZp5EILKPZddE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)