UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sg/+237pXZB9AfFaJHt1GOPdhM3joLkbmDpjmUsn3Aw='
WHERE
key_id = '1418c3ea60f69c49e792742328369b36bb3ce27d994e93210c7a724b9bd95095'
AND (
token = 'sg/+237pXZB9AfFaJHt1GOPdhM3joLkbmDpjmUsn3Aw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)