UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BcAvBeU47uCEoB+6yGVDE/6t1b7Di8hsWcwUFez1prg='
WHERE
key_id = 'd816dfa905c16d9a3d7171e6481a20920526fb8ad802f5e22a59f469d99f9596'
AND (
token = 'BcAvBeU47uCEoB+6yGVDE/6t1b7Di8hsWcwUFez1prg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)